﻿/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : wuye_int

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2016-06-30 16:12:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for customerOption
-- ----------------------------
/*用户问卷调查表*/
DROP TABLE IF EXISTS `customerOption`;
CREATE TABLE `customerOption` (
`wuye_customerOption_id`  smallint(60) NOT NULL AUTO_INCREMENT, /*主键id*/
`wuye_customerOption_name`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*问卷名称*/
`wuye_customerOption_sums`  varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*问卷参与人数*/
`wuye_customerOption_releaseTime`  datetime NULL DEFAULT NULL ,/*问卷发起时间*/
`wuye_customerOption_endTime`  datetime NULL DEFAULT NULL ,/*问卷结束时间*/
`wuye_customerOption_status`  varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*问卷状态*/
`wuye_customerOption_pollId`  smallint(60) NULL DEFAULT NULL ,/*问卷模板id  外键关联字段*/
`wuye_customerOption_pollName`  varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*问卷模板名称*/
PRIMARY KEY (`wuye_customerOption_id`),
INDEX `wuye_customerOption_pollId` (`wuye_customerOption_pollId`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of customerOption
-- ----------------------------
BEGIN;
INSERT INTO `customerOption` VALUES ('1', '物业一分公司调查问卷', '0', '2016-06-29 18:34:52', '2016-05-01 13:00:00', '1', '1', '物业一调查问卷'),
('2', '物业一分公司调查问卷', '0', '2016-06-29 18:34:52', '2016-05-01 13:00:00', '2', '1', '物业一调查问卷'),
('3', '物业一分公司调查问卷', '0', '2016-06-29 18:34:57', '2016-05-01 13:00:00', '3', '2', '物业一调查问卷2');
COMMIT;

-- ----------------------------
-- Table structure for wuye_optionDetail
-- ----------------------------
/*调查问卷模板属性详情表*/
DROP TABLE IF EXISTS `wuye_optionDetail`;
CREATE TABLE `wuye_optionDetail` (
`wuye_optionDetail_id`  smallint(60) NOT NULL AUTO_INCREMENT ,/*主键id*/
`wuye_optionDetail_name`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*属性名称*/
`wuye_optionDetail_parentId`  smallint(60) NULL DEFAULT NULL ,/*父类属性id*/
`wuye_optionDetail_parentName`  varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*父类属性名称*/
`wuye_optionDetail_pollId`  smallint(60) NOT NULL ,/*调查问卷模板id  外键关联字段*/
`wuye_optionDetail_opName1`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称1*/
`wuye_optionDetail_opName2`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称2*/
`wuye_optionDetail_opName3`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称3*/
`wuye_optionDetail_opName4`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称4*/
`wuye_optionDetail_opName5`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称5*/
`wuye_optionDetail_opName6`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称6*/
`wuye_optionDetail_opName7`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称7*/
`wuye_optionDetail_opName8`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*子属性名称8*/
PRIMARY KEY (`wuye_optionDetail_id`),
INDEX `wuye_optionDetail_pollId` (`wuye_optionDetail_pollId`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=19

;

-- ----------------------------
-- Records of wuye_optionDetail
-- ----------------------------
BEGIN;
INSERT INTO `wuye_optionDetail` VALUES ('1', '客服', null, '', '1', '', '', '', null, null, null, null, null), 
('2', '保卫', null, null, '1', '', '', '', null, null, null, null, null), 
('3', '设施', null, null, '1', '', '', '', null, null, null, null, null), 
('4', '服务态度', '1', '客服', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('5', '服务人员仪容仪表', '1', '客服', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('6', '服务态度，礼貌用语', '2', '保卫', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('7', '治安管理情况', '2', '保卫', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('8', '客服', null, null, '2', null, null, null, null, null, null, null, null), 
('9', '保卫', null, null, '2', null, null, null, null, null, null, null, null), 
('10', '设施', null, null, '2', null, null, null, null, null, null, null, null), 
('11', '服务态度，礼貌用语', '1', '客服', '2', '满意', '较满意', '不满意', null, null, null, null, null), 
('12', '服务人员仪容仪表', '1', '客服', '2', '满意', '较满意', '不满意', null, null, null, null, null), 
('13', '服务态度,礼貌用语', '2', '保卫', '2', '满意', '较满意', '不满意', null, null, null, null, null), 
('14', '治安管理情况', '2', '保卫', '2', '满意', '较满意', '不满意', null, null, null, null, null), 
('15', '设施是否齐备', '3', '设施', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('16', '设施是否安全', '3', '设施', '1', '满意', '较满意', '不满意', null, null, null, null, null), 
('17', '设施是否齐备', '3', '设施', '2', '满意', '较满意', '不满意', null, null, null, null, null), 
('18', '设施是否齐全', '3', '设施', '2', '满意', '较满意', '不满意', null, null, null, null, null);
COMMIT;

-- ----------------------------
-- Table structure for wuye_optionPoll
-- ----------------------------
/*用户调查模板表*/
DROP TABLE IF EXISTS `wuye_optionPoll`;
CREATE TABLE `wuye_optionPoll` (
`wuye_optionPoll_id`  smallint(60) NOT NULL AUTO_INCREMENT ,/*模板id*/
`wuye_optionPoll_name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '表单名称' ,
`wuye_optionPoll_createTime`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
PRIMARY KEY (`wuye_optionPoll_id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of wuye_optionPoll
-- ----------------------------
BEGIN;
INSERT INTO `wuye_optionPoll` VALUES ('1', '物业一调查问卷', '2016-06-20 00:00:00'),
('2', '物业一调查问卷2', '2016-06-20 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for wuye_record
-- ----------------------------
/*用户调查信息记录表*/
DROP TABLE IF EXISTS `wuye_record`;
CREATE TABLE `wuye_record` (
`wuye_record_id`  smallint(60) NOT NULL AUTO_INCREMENT ,/*主键id*/
`wuye_record_usId`  smallint(60) NULL DEFAULT NULL ,/*用户id*/
`wuye_record_custId`  smallint(60) NULL DEFAULT NULL ,/*调查信息表id*/
`wuye_record_primryId`  smallint(60) NULL DEFAULT NULL ,/*一级标题id*/
`wuye_record_secondId`  smallint(60) NULL DEFAULT NULL ,/*二级标题id*/
`wuye_record-selected`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*选中选项id*/
`wuye_record_message`  varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,/*问题调查意见*/
PRIMARY KEY (`wuye_record_id`),
INDEX `wuye_record_usId` (`wuye_record_usId`) USING BTREE ,
INDEX `wuye_record_custId` (`wuye_record_custId`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of wuye_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wuye_userOption
-- ----------------------------
/*用户信息与调查问卷表关系*/
DROP TABLE IF EXISTS `wuye_userOption`;
CREATE TABLE `wuye_userOption` (
`wuye_userOption_id`  smallint(11) NOT NULL AUTO_INCREMENT ,/*主键id*/
`wuye_userOption_uid`  smallint(60) NULL DEFAULT NULL ,/*用户id*/
`wuye_userOption_cusId`  smallint(60) NULL DEFAULT NULL ,/*调查问卷表id*/
`wuye_userOption_subTime`  datetime NULL DEFAULT NULL ,/*提交问卷时间*/
`wuye_userOption_userName`  varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户名称*/
`wuye_userOption_telphone`  varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户联系方式*/
`wuye_userOption_company`  varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户所在公司*/
`wuye_userOption_isWritten`  varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户是否填写*/
`wuye_userOption_isIn`  varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户是否参与*/
`wuye_userOption_ortherSuggest`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户对调查表其他意见*/
`wuye_userOption_suggest`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ,/*用户意见*/
PRIMARY KEY (`wuye_userOption_id`),
INDEX `wuye_userOption_uid` (`wuye_userOption_uid`) USING BTREE ,
INDEX `wuye_userOption_cusId` (`wuye_userOption_cusId`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of wuye_userOption
-- ----------------------------
BEGIN;
INSERT INTO `wuye_userOption` VALUES ('1', '200', '1', '2016-06-28 13:00:00', 'zhanchi', '88888888', '物业一公司', '1', '1', '活动很有意义', '下次会再次参与'),
('2', '200', '2', '2016-06-25 08:00:00', 'zhanchi', '88888888', '物业一公司', '1', '1', '活动很有意思', '下次会再次参与'),
('3', '200', '3', '2016-06-25 08:00:00', 'zhanchi', '88888888', '物业一公司', '0', '1', '', '');
COMMIT;

-- ----------------------------
-- Auto increment value for customerOption
-- ----------------------------
ALTER TABLE `customerOption` AUTO_INCREMENT=4;

-- ----------------------------
-- Auto increment value for wuye_optionDetail
-- ----------------------------
ALTER TABLE `wuye_optionDetail` AUTO_INCREMENT=19;

-- ----------------------------
-- Auto increment value for wuye_optionPoll
-- ----------------------------
ALTER TABLE `wuye_optionPoll` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for wuye_record
-- ----------------------------
ALTER TABLE `wuye_record` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for wuye_userOption
-- ----------------------------
ALTER TABLE `wuye_userOption` AUTO_INCREMENT=4;
